package com.zmj.sy.mom.srv.aps.mapper;

import com.zmj.sy.mom.srv.aps.bean.entity.third.SinoCamReceiveNestExcess;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface SinoCamReceiveNestExcessMapper extends SyMapper<SinoCamReceiveNestExcess> {

    @Select("DELETE FROM tb_third_sinocam_receive_nest_excess WHERE sino_cam_id=#{sId}")
    void deletePreOrder(@Param("sId") Integer sId);

    @Select("DELETE FROM tb_third_sinocam_receive_nest_excess WHERE id = #{id}")
    void deleteMesNest(@Param("id") Integer id);

    @Select("DELETE FROM tb_third_sinocam_receive_nest_excess WHERE stock_list_no = #{plateCode}")
    void deleteMesNestWithCode(@Param("plateCode") String plateCode);

}
